Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 191563 |
| Missing cells | 708906 |
| Missing cells (%) | 13.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.1 MiB |
| Average record size in memory | 203.0 B |
Variable types
| CAT | 15 |
|---|---|
| NUM | 9 |
| BOOL | 4 |
account_creation_date has a high cardinality: 190383 distinct values | High cardinality |
trial_end_date has a high cardinality: 190383 distinct values | High cardinality |
last_payment has a high cardinality: 106702 distinct values | High cardinality |
next_payment has a high cardinality: 104772 distinct values | High cardinality |
cancel_date has a high cardinality: 284 distinct values | High cardinality |
discount_price is highly correlated with monthly_price and 1 other fields | High correlation |
monthly_price is highly correlated with discount_price and 1 other fields | High correlation |
num_trial_days is highly correlated with monthly_price and 1 other fields | High correlation |
num_trial_days is highly correlated with plan_type | High correlation |
plan_type is highly correlated with num_trial_days | High correlation |
package_type has 35361 (18.5%) missing values | Missing |
num_weekly_services_utilized has 74802 (39.0%) missing values | Missing |
preferred_genre has 36107 (18.8%) missing values | Missing |
intended_use has 3502 (1.8%) missing values | Missing |
weekly_consumption_hour has 2755 (1.4%) missing values | Missing |
num_ideal_streaming_services has 76518 (39.9%) missing values | Missing |
attribution_survey has 2602 (1.4%) missing values | Missing |
op_sys has 12986 (6.8%) missing values | Missing |
payment_type has 134856 (70.4%) missing values | Missing |
last_payment has 84275 (44.0%) missing values | Missing |
next_payment has 86098 (44.9%) missing values | Missing |
cancel_date has 159040 (83.0%) missing values | Missing |
monthly_price is highly skewed (γ1 = -32.62319544) | Skewed |
discount_price is highly skewed (γ1 = -31.4084658) | Skewed |
account_creation_date is uniformly distributed | Uniform |
trial_end_date is uniformly distributed | Uniform |
last_payment is uniformly distributed | Uniform |
next_payment is uniformly distributed | Uniform |
df_index has unique values | Unique |
subid has unique values | Unique |
join_fee has 33089 (17.3%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-12 13:51:22.668997 |
|---|---|
| Analysis finished | 2020-12-12 13:53:04.349768 |
| Duration | 1 minute and 41.68 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 191563 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113752.0782 |
|---|---|
| Minimum | 1 |
| Maximum | 227627 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 11325.1 |
| Q1 | 56788.5 |
| median | 113852 |
| Q3 | 170635.5 |
| 95-th percentile | 216214.9 |
| Maximum | 227627 |
| Range | 227626 |
| Interquartile range (IQR) | 113847 |
Descriptive statistics
| Standard deviation | 65738.24676 |
|---|---|
| Coefficient of variation (CV) | 0.5779080943 |
| Kurtosis | -1.200385816 |
| Mean | 113752.0782 |
| Median Absolute Deviation (MAD) | 56920 |
| Skewness | -0.0005193121325 |
| Sum | 2.179068936e+10 |
| Variance | 4321517087 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 4094 | 1 | < 0.1% | |
| 75150 | 1 | < 0.1% | |
| 105881 | 1 | < 0.1% | |
| 103832 | 1 | < 0.1% | |
| 126359 | 1 | < 0.1% | |
| 128404 | 1 | < 0.1% | |
| 118163 | 1 | < 0.1% | |
| 116114 | 1 | < 0.1% | |
| 122257 | 1 | < 0.1% | |
| 120208 | 1 | < 0.1% | |
| Other values (191553) | 191553 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 227627 | 1 | < 0.1% | |
| 227625 | 1 | < 0.1% | |
| 227624 | 1 | < 0.1% | |
| 227623 | 1 | < 0.1% | |
| 227622 | 1 | < 0.1% |
| Distinct | 191563 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24986379 |
|---|---|
| Minimum | 20000009 |
| Maximum | 29999982 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 20000009 |
|---|---|
| 5-th percentile | 20499195.7 |
| Q1 | 22490128.5 |
| median | 24971020 |
| Q3 | 27487834.5 |
| 95-th percentile | 29491790.3 |
| Maximum | 29999982 |
| Range | 9999973 |
| Interquartile range (IQR) | 4997706 |
Descriptive statistics
| Standard deviation | 2883893.76 |
|---|---|
| Coefficient of variation (CV) | 0.1154186351 |
| Kurtosis | -1.198724491 |
| Mean | 24986379 |
| Median Absolute Deviation (MAD) | 2498988 |
| Skewness | 0.008486716085 |
| Sum | 4.78646572e+12 |
| Variance | 8.316843222e+12 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 24643583 | 1 | < 0.1% | |
| 26322192 | 1 | < 0.1% | |
| 23442816 | 1 | < 0.1% | |
| 20217253 | 1 | < 0.1% | |
| 20550169 | 1 | < 0.1% | |
| 24399267 | 1 | < 0.1% | |
| 23348642 | 1 | < 0.1% | |
| 20738546 | 1 | < 0.1% | |
| 20207008 | 1 | < 0.1% | |
| 22212172 | 1 | < 0.1% | |
| Other values (191553) | 191553 | > 99.9% |
| Value | Count | Frequency (%) | |
| 20000009 | 1 | < 0.1% | |
| 20000048 | 1 | < 0.1% | |
| 20000062 | 1 | < 0.1% | |
| 20000094 | 1 | < 0.1% | |
| 20000104 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29999982 | 1 | < 0.1% | |
| 29999945 | 1 | < 0.1% | |
| 29999904 | 1 | < 0.1% | |
| 29999879 | 1 | < 0.1% | |
| 29999862 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35361 |
| Missing (%) | 18.5% |
| Memory size | 1.5 MiB |
| base | |
|---|---|
| enhanced | |
| economy |
| Value | Count | Frequency (%) | |
| base | 86886 | 45.4% | |
| enhanced | 53373 | 27.9% | |
| economy | 15943 | 8.3% | |
| (Missing) | 35361 | 18.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 5.179559727 |
| Min length | 3 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 74802 |
| Missing (%) | 39.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.008984164 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8208150659 |
|---|---|
| Coefficient of variation (CV) | 0.2727880976 |
| Kurtosis | 2.353599881 |
| Mean | 3.008984164 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.023508238 |
| Sum | 351332 |
| Variance | 0.6737373725 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 63701 | 33.3% | |
| 2 | 29670 | 15.5% | |
| 4 | 17269 | 9.0% | |
| 5 | 5016 | 2.6% | |
| 6 | 904 | 0.5% | |
| 7 | 138 | 0.1% | |
| 1 | 24 | < 0.1% | |
| 8 | 22 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| Other values (2) | 3 | < 0.1% | |
| (Missing) | 74802 | 39.0% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 24 | < 0.1% | |
| 2 | 29670 | 15.5% | |
| 3 | 63701 | 33.3% | |
| 4 | 17269 | 9.0% |
| Value | Count | Frequency (%) | |
| 14 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 8 | 22 | < 0.1% | |
| 7 | 138 | 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 36107 |
| Missing (%) | 18.8% |
| Memory size | 1.5 MiB |
| comedy | |
|---|---|
| drama | |
| regional | 8418 |
| international | 6063 |
| other | 3778 |
| Value | Count | Frequency (%) | |
| comedy | 97258 | 50.8% | |
| drama | 39939 | 20.8% | |
| regional | 8418 | 4.4% | |
| international | 6063 | 3.2% | |
| other | 3778 | 2.0% | |
| (Missing) | 36107 | 18.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 5.515767659 |
| Min length | 3 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3502 |
| Missing (%) | 1.8% |
| Memory size | 1.5 MiB |
| access to exclusive content | |
|---|---|
| replace OTT | |
| supplement OTT | |
| expand regional access | |
| expand international access | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| access to exclusive content | 69727 | 36.4% | |
| replace OTT | 56278 | 29.4% | |
| supplement OTT | 23233 | 12.1% | |
| expand regional access | 13941 | 7.3% | |
| expand international access | 12929 | 6.7% | |
| other | 6849 | 3.6% | |
| education | 5104 | 2.7% | |
| (Missing) | 3502 | 1.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 18.65402505 |
| Min length | 3 |
| Distinct | 81 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2755 |
| Missing (%) | 1.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.00112139 |
|---|---|
| Minimum | -32.1467596 |
| Maximum | 76.59996225 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -32.1467596 |
|---|---|
| 5-th percentile | 21.50162318 |
| Q1 | 24.40153577 |
| median | 27.30144835 |
| Q3 | 30.20136093 |
| 95-th percentile | 37.45114239 |
| Maximum | 76.59996225 |
| Range | 108.7467219 |
| Interquartile range (IQR) | 5.799825165 |
Descriptive statistics
| Standard deviation | 4.977112143 |
|---|---|
| Coefficient of variation (CV) | 0.1777468864 |
| Kurtosis | 3.173344778 |
| Mean | 28.00112139 |
| Median Absolute Deviation (MAD) | 2.899912583 |
| Skewness | 0.6404438306 |
| Sum | 5286835.728 |
| Variance | 24.77164528 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 25.85149206 | 25863 | 13.5% | |
| 28.75140464 | 22848 | 11.9% | |
| 27.30144835 | 22436 | 11.7% | |
| 24.40153577 | 19869 | 10.4% | |
| 30.20136093 | 18298 | 9.6% | |
| 22.95157947 | 16732 | 8.7% | |
| 31.65131722 | 13199 | 6.9% | |
| 33.10127351 | 9378 | 4.9% | |
| 21.50162318 | 8665 | 4.5% | |
| 34.5512298 | 7398 | 3.9% | |
| Other values (71) | 24122 | 12.6% |
| Value | Count | Frequency (%) | |
| -32.1467596 | 1 | < 0.1% | |
| -29.24684701 | 4 | < 0.1% | |
| -27.79689072 | 1 | < 0.1% | |
| -23.44702185 | 1 | < 0.1% | |
| -13.29732781 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 76.59996225 | 3 | < 0.1% | |
| 75.15000596 | 3 | < 0.1% | |
| 73.70004967 | 1 | < 0.1% | |
| 72.25009338 | 5 | < 0.1% | |
| 67.90022451 | 5 | < 0.1% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 76518 |
| Missing (%) | 39.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.061262984 |
|---|---|
| Minimum | -1 |
| Maximum | 7 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 7 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2459331339 |
|---|---|
| Coefficient of variation (CV) | 0.1193118665 |
| Kurtosis | 14.18847432 |
| Mean | 2.061262984 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.601336973 |
| Sum | 237138 |
| Variance | 0.06048310636 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 107857 | 56.3% | |
| 3 | 7047 | 3.7% | |
| 1 | 89 | < 0.1% | |
| 4 | 42 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 0 | 4 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| -1 | 1 | < 0.1% | |
| (Missing) | 76518 | 39.9% |
| Value | Count | Frequency (%) | |
| -1 | 1 | < 0.1% | |
| 0 | 4 | < 0.1% | |
| 1 | 89 | < 0.1% | |
| 2 | 107857 | 56.3% | |
| 3 | 7047 | 3.7% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 4 | 42 | < 0.1% | |
| 3 | 7047 | 3.7% | |
| 2 | 107857 | 56.3% |
age
Real number (ℝ≥0)
| Distinct | 95 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.15751248 |
|---|---|
| Minimum | 0 |
| Maximum | 90 |
| Zeros | 64 |
| Zeros (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 35 |
| median | 46 |
| Q3 | 57 |
| 95-th percentile | 70 |
| Maximum | 90 |
| Range | 90 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.97657738 |
|---|---|
| Coefficient of variation (CV) | 0.3028017895 |
| Kurtosis | -0.7493570161 |
| Mean | 46.15751248 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.08003035382 |
| Sum | 8842071.563 |
| Variance | 195.3447151 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 50 | 6355 | 3.3% | |
| 40 | 5509 | 2.9% | |
| 60 | 5221 | 2.7% | |
| 48 | 4651 | 2.4% | |
| 47 | 4517 | 2.4% | |
| 55 | 4509 | 2.4% | |
| 49 | 4483 | 2.3% | |
| 52 | 4440 | 2.3% | |
| 43 | 4357 | 2.3% | |
| 42 | 4346 | 2.3% | |
| Other values (85) | 143175 | 74.7% |
| Value | Count | Frequency (%) | |
| 0 | 64 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 18 | 1097 | 0.6% | |
| 19 | 632 | 0.3% |
| Value | Count | Frequency (%) | |
| 90 | 2 | < 0.1% | |
| 89 | 7 | < 0.1% | |
| 88 | 8 | < 0.1% | |
| 87 | 13 | < 0.1% | |
| 86 | 14 | < 0.1% |
male_TF
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| False | |
|---|---|
| True | |
| (Missing) | 4 |
| Value | Count | Frequency (%) | |
| False | 166771 | 87.1% | |
| True | 24788 | 12.9% | |
| (Missing) | 4 | < 0.1% |
attribution_technical
Categorical
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| search | |
|---|---|
| organic | |
| brand sem intent google | |
| Other values (28) |
| Value | Count | Frequency (%) | |
| 62809 | 32.8% | ||
| search | 22080 | 11.5% | |
| 21109 | 11.0% | ||
| organic | 18683 | 9.8% | |
| brand sem intent google | 15821 | 8.3% | |
| google_organic | 9553 | 5.0% | |
| affiliate | 9318 | 4.9% | |
| email_blast | 6321 | 3.3% | |
| 5634 | 2.9% | ||
| referral | 4005 | 2.1% | |
| Other values (23) | 16230 | 8.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 23 |
|---|---|
| Median length | 8 |
| Mean length | 9.270464547 |
| Min length | 2 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2602 |
| Missing (%) | 1.4% |
| Memory size | 1.5 MiB |
| tv | |
|---|---|
| referral | |
| search | 8084 |
| 7393 | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| 93584 | 48.9% | ||
| tv | 34737 | 18.1% | |
| referral | 17102 | 8.9% | |
| search | 8084 | 4.2% | |
| 7393 | 3.9% | ||
| other | 6423 | 3.4% | |
| public_radio | 5897 | 3.1% | |
| social_organic | 3735 | 1.9% | |
| youtube | 3086 | 1.6% | |
| podcast | 2921 | 1.5% | |
| Other values (6) | 5999 | 3.1% | |
| (Missing) | 2602 | 1.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 16 |
|---|---|
| Median length | 8 |
| Mean length | 6.926488936 |
| Min length | 2 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 12986 |
| Missing (%) | 6.8% |
| Memory size | 1.5 MiB |
| iOS | |
|---|---|
| Android |
| Value | Count | Frequency (%) | |
| iOS | 116419 | 60.8% | |
| Android | 62158 | 32.4% | |
| (Missing) | 12986 | 6.8% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 4.297912436 |
| Min length | 3 |
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| base_uae_14_day_trial | |
|---|---|
| high_uae_14_day_trial | 325 |
| low_uae_no_trial | 166 |
| base_eur_14_day_trial | 18 |
| high_sar_14_day_trial | 12 |
| Other values (6) | 10 |
| Value | Count | Frequency (%) | |
| base_uae_14_day_trial | 191032 | 99.7% | |
| high_uae_14_day_trial | 325 | 0.2% | |
| low_uae_no_trial | 166 | 0.1% | |
| base_eur_14_day_trial | 18 | < 0.1% | |
| high_sar_14_day_trial | 12 | < 0.1% | |
| low_gbp_14_day_trial | 4 | < 0.1% | |
| high_aud_14_day_trial | 2 | < 0.1% | |
| high_jpy_14_day_trial | 1 | < 0.1% | |
| base_uae_no_trial_7_day_guarantee | 1 | < 0.1% | |
| low_eur_no_trial | 1 | < 0.1% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 33 |
|---|---|
| Median length | 21 |
| Mean length | 20.99565678 |
| Min length | 16 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.731644867 |
|---|---|
| Minimum | 0.8074 |
| Maximum | 5.1013 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0.8074 |
|---|---|
| 5-th percentile | 4.7343 |
| Q1 | 4.7343 |
| median | 4.7343 |
| Q3 | 4.7343 |
| 95-th percentile | 4.7343 |
| Maximum | 5.1013 |
| Range | 4.2939 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1098266661 |
|---|---|
| Coefficient of variation (CV) | 0.0232110966 |
| Kurtosis | 1088.933009 |
| Mean | 4.731644867 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -32.62319544 |
| Sum | 906408.0856 |
| Variance | 0.01206189658 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4.7343 | 191037 | 99.7% | |
| 5.1013 | 325 | 0.2% | |
| 1.0643 | 166 | 0.1% | |
| 4.4407 | 18 | < 0.1% | |
| 4.3673 | 12 | < 0.1% | |
| 4.0003 | 2 | < 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 0.8074 | 1 | < 0.1% | |
| 4.6976 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.8074 | 1 | < 0.1% | |
| 1.0643 | 166 | 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 4.0003 | 2 | < 0.1% | |
| 4.3673 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5.1013 | 325 | 0.2% | |
| 4.7343 | 191037 | 99.7% | |
| 4.6976 | 1 | < 0.1% | |
| 4.4407 | 18 | < 0.1% | |
| 4.3673 | 12 | < 0.1% |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.511846805 |
|---|---|
| Minimum | 0.7707 |
| Maximum | 5.0279 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0.7707 |
|---|---|
| 5-th percentile | 4.5141 |
| Q1 | 4.5141 |
| median | 4.5141 |
| Q3 | 4.5141 |
| 95-th percentile | 4.5141 |
| Maximum | 5.0279 |
| Range | 4.2572 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.105518673 |
|---|---|
| Coefficient of variation (CV) | 0.02338702478 |
| Kurtosis | 1041.714144 |
| Mean | 4.511846805 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -31.4084658 |
| Sum | 864302.9096 |
| Variance | 0.01113419036 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4.5141 | 191032 | 99.7% | |
| 5.0279 | 325 | 0.2% | |
| 1.0276 | 166 | 0.1% | |
| 4.2205 | 18 | < 0.1% | |
| 4.0737 | 12 | < 0.1% | |
| 4.3673 | 4 | < 0.1% | |
| 4.4407 | 2 | < 0.1% | |
| 3.7801 | 2 | < 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 0.7707 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.7707 | 1 | < 0.1% | |
| 1.0276 | 166 | 0.1% | |
| 1.1744 | 1 | < 0.1% | |
| 3.7801 | 2 | < 0.1% | |
| 4.0737 | 12 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5.0279 | 325 | 0.2% | |
| 4.5141 | 191032 | 99.7% | |
| 4.4407 | 2 | < 0.1% | |
| 4.3673 | 4 | < 0.1% | |
| 4.2205 | 18 | < 0.1% |
| Distinct | 190383 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 2019-07-02 14:58:45 | 3 |
|---|---|
| 2019-07-01 01:21:10 | 3 |
| 2020-02-29 19:26:26 | 3 |
| 2019-12-28 16:35:34 | 3 |
| 2020-02-29 17:58:30 | 3 |
| Other values (190378) |
| Value | Count | Frequency (%) | |
| 2019-07-02 14:58:45 | 3 | < 0.1% | |
| 2019-07-01 01:21:10 | 3 | < 0.1% | |
| 2020-02-29 19:26:26 | 3 | < 0.1% | |
| 2019-12-28 16:35:34 | 3 | < 0.1% | |
| 2020-02-29 17:58:30 | 3 | < 0.1% | |
| 2019-06-30 14:47:57 | 3 | < 0.1% | |
| 2019-10-26 12:15:45 | 2 | < 0.1% | |
| 2019-08-15 18:32:54 | 2 | < 0.1% | |
| 2019-07-04 17:04:47 | 2 | < 0.1% | |
| 2020-01-06 13:05:15 | 2 | < 0.1% | |
| Other values (190373) | 191537 | > 99.9% |
Unique
| Unique | 189209 ? |
|---|---|
| Unique (%) | 98.8% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 190383 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 2019-07-14 14:47:57 | 3 |
|---|---|
| 2020-01-11 16:35:34 | 3 |
| 2020-03-14 19:26:26 | 3 |
| 2019-07-16 14:58:45 | 3 |
| 2019-07-15 01:21:10 | 3 |
| Other values (190378) |
| Value | Count | Frequency (%) | |
| 2019-07-14 14:47:57 | 3 | < 0.1% | |
| 2020-01-11 16:35:34 | 3 | < 0.1% | |
| 2020-03-14 19:26:26 | 3 | < 0.1% | |
| 2019-07-16 14:58:45 | 3 | < 0.1% | |
| 2019-07-15 01:21:10 | 3 | < 0.1% | |
| 2020-03-14 17:58:30 | 3 | < 0.1% | |
| 2019-07-29 22:13:18 | 2 | < 0.1% | |
| 2019-07-18 18:39:31 | 2 | < 0.1% | |
| 2019-11-20 03:40:21 | 2 | < 0.1% | |
| 2020-03-12 15:11:11 | 2 | < 0.1% | |
| Other values (190373) | 191537 | > 99.9% |
Unique
| Unique | 189209 ? |
|---|---|
| Unique (%) | 98.8% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
initial_credit_card_declined
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 187.1 KiB |
| False | |
|---|---|
| True | 11112 |
| Value | Count | Frequency (%) | |
| False | 180451 | 94.2% | |
| True | 11112 | 5.8% |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1152957006 |
|---|---|
| Minimum | -0.6606 |
| Maximum | 0.734 |
| Zeros | 33089 |
| Zeros (%) | 17.3% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -0.6606 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.0367 |
| median | 0.0367 |
| Q3 | 0.1101 |
| 95-th percentile | 0.6606 |
| Maximum | 0.734 |
| Range | 1.3946 |
| Interquartile range (IQR) | 0.0734 |
Descriptive statistics
| Standard deviation | 0.1770207005 |
|---|---|
| Coefficient of variation (CV) | 1.535362546 |
| Kurtosis | 3.123783389 |
| Mean | 0.1152957006 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.024318696 |
| Sum | 22086.3903 |
| Variance | 0.03133632839 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0.0367 | 108927 | 56.9% | |
| 0 | 33089 | 17.3% | |
| 0.3303 | 25200 | 13.2% | |
| 0.6606 | 12219 | 6.4% | |
| 0.1101 | 10617 | 5.5% | |
| 0.367 | 1328 | 0.7% | |
| 0.1835 | 146 | 0.1% | |
| -0.0367 | 9 | < 0.1% | |
| 0.6973 | 8 | < 0.1% | |
| 0.6239 | 6 | < 0.1% | |
| Other values (10) | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| -0.6606 | 2 | < 0.1% | |
| -0.3303 | 1 | < 0.1% | |
| -0.1101 | 1 | < 0.1% | |
| -0.0367 | 9 | < 0.1% | |
| 0 | 33089 | 17.3% |
| Value | Count | Frequency (%) | |
| 0.734 | 1 | < 0.1% | |
| 0.6973 | 8 | < 0.1% | |
| 0.6606 | 12219 | 6.4% | |
| 0.6239 | 6 | < 0.1% | |
| 0.5872 | 1 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 134856 |
| Missing (%) | 70.4% |
| Memory size | 1.5 MiB |
| Standard Charter | |
|---|---|
| Paypal | |
| RAKBANK | |
| CBD | |
| Najim | 2115 |
| Value | Count | Frequency (%) | |
| Standard Charter | 22307 | 11.6% | |
| Paypal | 17910 | 9.3% | |
| RAKBANK | 10177 | 5.3% | |
| CBD | 4194 | 2.2% | |
| Najim | 2115 | 1.1% | |
| Apple Pay | 4 | < 0.1% | |
| (Missing) | 134856 | 70.4% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 16 |
|---|---|
| Median length | 3 |
| Mean length | 5.029008733 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 14 | |
|---|---|
| 0 | 169 |
| Value | Count | Frequency (%) | |
| 14 | 191394 | 99.9% | |
| 0 | 169 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.999117784 |
| Min length | 1 |
current_sub_TF
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 187.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 105465 | 55.1% | |
| False | 86098 | 44.9% |
payment_period
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 | 2311 |
| Value | Count | Frequency (%) | |
| 0 | 84275 | 44.0% | |
| 1 | 70204 | 36.6% | |
| 2 | 34773 | 18.2% | |
| 3 | 2311 | 1.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct | 106702 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 84275 |
| Missing (%) | 44.0% |
| Memory size | 1.5 MiB |
| 2020-03-08 19:00:43 | 3 |
|---|---|
| 2020-02-29 12:16:18 | 3 |
| 2020-03-14 19:26:26 | 3 |
| 2020-03-15 18:08:08 | 2 |
| 2020-03-15 12:43:15 | 2 |
| Other values (106697) |
| Value | Count | Frequency (%) | |
| 2020-03-08 19:00:43 | 3 | < 0.1% | |
| 2020-02-29 12:16:18 | 3 | < 0.1% | |
| 2020-03-14 19:26:26 | 3 | < 0.1% | |
| 2020-03-15 18:08:08 | 2 | < 0.1% | |
| 2020-03-15 12:43:15 | 2 | < 0.1% | |
| 2020-02-29 14:35:44 | 2 | < 0.1% | |
| 2020-03-26 16:03:32 | 2 | < 0.1% | |
| 2020-03-02 18:23:29 | 2 | < 0.1% | |
| 2020-03-22 12:15:25 | 2 | < 0.1% | |
| 2020-02-15 21:29:54 | 2 | < 0.1% | |
| Other values (106692) | 107265 | 56.0% | |
| (Missing) | 84275 | 44.0% |
Unique
| Unique | 106119 ? |
|---|---|
| Unique (%) | 98.9% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 11.96106242 |
| Min length | 3 |
| Distinct | 104772 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 86098 |
| Missing (%) | 44.9% |
| Memory size | 1.5 MiB |
| 2020-06-29 12:16:18 | 3 |
|---|---|
| 2020-07-08 19:00:43 | 3 |
| 2020-07-14 19:26:26 | 3 |
| 2020-07-25 15:36:42 | 2 |
| 2020-05-24 12:32:38 | 2 |
| Other values (104767) |
| Value | Count | Frequency (%) | |
| 2020-06-29 12:16:18 | 3 | < 0.1% | |
| 2020-07-08 19:00:43 | 3 | < 0.1% | |
| 2020-07-14 19:26:26 | 3 | < 0.1% | |
| 2020-07-25 15:36:42 | 2 | < 0.1% | |
| 2020-05-24 12:32:38 | 2 | < 0.1% | |
| 2020-04-30 15:23:34 | 2 | < 0.1% | |
| 2020-04-21 02:03:47 | 2 | < 0.1% | |
| 2020-04-15 02:54:00 | 2 | < 0.1% | |
| 2020-03-30 14:39:34 | 2 | < 0.1% | |
| 2020-06-12 02:52:49 | 2 | < 0.1% | |
| Other values (104762) | 105442 | 55.0% | |
| (Missing) | 86098 | 44.9% |
Unique
| Unique | 104082 ? |
|---|---|
| Unique (%) | 98.7% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 11.80879919 |
| Min length | 3 |
| Distinct | 284 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 159040 |
| Missing (%) | 83.0% |
| Memory size | 1.5 MiB |
| 2019-07-13 00:00:00 | 430 |
|---|---|
| 2019-07-12 00:00:00 | 391 |
| 2019-07-14 00:00:00 | 382 |
| 2019-07-15 00:00:00 | 346 |
| 2019-07-11 00:00:00 | 321 |
| Other values (279) |
| Value | Count | Frequency (%) | |
| 2019-07-13 00:00:00 | 430 | 0.2% | |
| 2019-07-12 00:00:00 | 391 | 0.2% | |
| 2019-07-14 00:00:00 | 382 | 0.2% | |
| 2019-07-15 00:00:00 | 346 | 0.2% | |
| 2019-07-11 00:00:00 | 321 | 0.2% | |
| 2019-07-16 00:00:00 | 313 | 0.2% | |
| 2019-07-17 00:00:00 | 300 | 0.2% | |
| 2019-07-10 00:00:00 | 286 | 0.1% | |
| 2019-07-09 00:00:00 | 257 | 0.1% | |
| 2019-07-18 00:00:00 | 254 | 0.1% | |
| Other values (274) | 29243 | 15.3% | |
| (Missing) | 159040 | 83.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 19 |
|---|---|
| Median length | 3 |
| Mean length | 5.716432714 |
| Min length | 3 |
trial_completed
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 187.1 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 167235 | 87.3% | |
| False | 24328 | 12.7% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | subid | package_type | num_weekly_services_utilized | preferred_genre | intended_use | weekly_consumption_hour | num_ideal_streaming_services | age | male_TF | attribution_technical | attribution_survey | op_sys | plan_type | monthly_price | discount_price | account_creation_date | trial_end_date | initial_credit_card_declined | join_fee | payment_type | num_trial_days | current_sub_TF | payment_period | last_payment | next_payment | cancel_date | trial_completed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 23383224 | base | NaN | comedy | access to exclusive content | 22.951579 | NaN | 70.0 | False | NaN | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-01 15:44:35 | 2020-03-15 15:44:35 | False | 0.3303 | NaN | 14 | True | 1 | 2020-03-15 15:44:35 | 2020-07-15 15:44:35 | NaN | True | ||
| 1 | 2 | 26844789 | enhanced | 3.0 | regional | replace OTT | 36.001186 | 2.0 | 25.0 | True | organic | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-07 16:37:06 | 2019-12-21 16:37:06 | False | 0.1101 | NaN | 14 | False | 0 | NaN | NaN | NaN | True | |
| 2 | 3 | 29417030 | base | NaN | drama | replace OTT | 20.051667 | NaN | 30.0 | False | search | tv | Android | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-27 16:09:32 | 2020-02-10 16:09:32 | False | 0.0367 | NaN | 14 | False | 0 | NaN | NaN | NaN | True |
| 3 | 4 | 26723159 | base | 4.0 | comedy | replace OTT | 22.951579 | 3.0 | 28.0 | False | discovery | youtube | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-10-05 12:57:07 | 2019-10-19 12:57:07 | False | 0.0367 | NaN | 14 | True | 2 | 2020-02-19 12:57:07 | 2020-06-19 12:57:07 | NaN | True |
| 4 | 5 | 24810928 | base | NaN | comedy | access to exclusive content | 20.051667 | NaN | 70.0 | False | bing | tv | NaN | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-03 20:15:43 | 2020-03-17 20:15:43 | False | 0.3303 | RAKBANK | 14 | True | 1 | 2020-03-17 20:15:43 | 2020-07-17 20:15:43 | NaN | True |
| 5 | 6 | 29726122 | base | 2.0 | comedy | access to exclusive content | 20.051667 | 2.0 | 61.0 | False | bing | search | Android | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-19 18:30:15 | 2020-03-04 18:30:15 | False | 0.3303 | Standard Charter | 14 | True | 1 | 2020-03-04 18:30:15 | 2020-07-04 18:30:15 | NaN | True |
| 6 | 7 | 20299962 | base | 3.0 | drama | access to exclusive content | 34.551230 | 2.0 | 23.0 | False | referral | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-05 14:52:22 | 2020-03-19 14:52:22 | False | 0.0000 | RAKBANK | 14 | True | 1 | 2020-03-19 14:52:22 | 2020-07-19 14:52:22 | NaN | True | |
| 7 | 8 | 24930568 | base | NaN | comedy | access to exclusive content | 25.851492 | NaN | 73.0 | False | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-23 17:50:25 | 2020-03-08 17:50:25 | False | 0.6606 | NaN | 14 | True | 1 | 2020-03-08 17:50:25 | 2020-07-08 17:50:25 | NaN | True | ||
| 8 | 9 | 23452753 | economy | 3.0 | drama | replace OTT | 28.751405 | 2.0 | 71.0 | False | search | Android | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-21 14:17:53 | 2020-02-04 14:17:53 | False | 0.3303 | NaN | 14 | False | 0 | NaN | NaN | 2020-01-27 00:00:00 | False | |
| 9 | 10 | 21191741 | NaN | NaN | NaN | expand regional access | 34.551230 | NaN | 53.0 | True | organic | public_radio | NaN | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-07-11 16:00:42 | 2019-07-25 16:00:42 | False | 0.0367 | Standard Charter | 14 | False | 1 | 2019-07-25 16:00:42 | NaN | 2019-08-20 00:00:00 | True |
Last rows
| df_index | subid | package_type | num_weekly_services_utilized | preferred_genre | intended_use | weekly_consumption_hour | num_ideal_streaming_services | age | male_TF | attribution_technical | attribution_survey | op_sys | plan_type | monthly_price | discount_price | account_creation_date | trial_end_date | initial_credit_card_declined | join_fee | payment_type | num_trial_days | current_sub_TF | payment_period | last_payment | next_payment | cancel_date | trial_completed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191553 | 227615 | 22117405 | base | NaN | comedy | access to exclusive content | 24.401536 | NaN | 30.0 | False | youtube | NaN | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-03 13:56:33 | 2020-02-17 13:56:33 | False | 0.0367 | Paypal | 14 | True | 1 | 2020-02-17 13:56:33 | 2020-06-17 13:56:33 | NaN | True | |
| 191554 | 227616 | 26828621 | base | 4.0 | drama | access to exclusive content | 27.301448 | 2.0 | 44.0 | False | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-02-26 02:12:05 | 2020-03-11 02:12:05 | False | 0.0000 | Standard Charter | 14 | True | 1 | 2020-03-11 02:12:05 | 2020-07-11 02:12:05 | NaN | True | ||
| 191555 | 227618 | 22218943 | economy | NaN | comedy | replace OTT | 37.451142 | NaN | 67.0 | True | brand sem intent bing | referral | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-16 02:53:50 | 2019-11-30 02:53:50 | False | 0.0367 | NaN | 14 | False | 0 | NaN | NaN | 2019-11-27 00:00:00 | False |
| 191556 | 227619 | 25492551 | base | 3.0 | comedy | access to exclusive content | 30.201361 | 2.0 | 32.0 | False | Android | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-09-30 22:07:37 | 2019-10-14 22:07:37 | False | 0.0000 | NaN | 14 | True | 2 | 2020-02-14 22:07:37 | 2020-06-14 22:07:37 | NaN | True | ||
| 191557 | 227621 | 25549852 | enhanced | NaN | comedy | access to exclusive content | 28.751405 | NaN | 61.0 | False | affiliate | Android | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-03-06 02:57:03 | 2020-03-20 02:57:03 | False | 0.3303 | NaN | 14 | True | 1 | 2020-03-20 02:57:03 | 2020-07-20 02:57:03 | NaN | True | |
| 191558 | 227622 | 25835684 | base | 2.0 | drama | access to exclusive content | 24.401536 | 2.0 | 43.0 | False | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2020-01-01 22:43:56 | 2020-01-15 22:43:56 | False | 0.0000 | NaN | 14 | True | 1 | 2020-01-15 22:43:56 | 2020-05-15 22:43:56 | NaN | True | ||
| 191559 | 227623 | 21434712 | enhanced | 3.0 | comedy | supplement OTT | 28.751405 | 2.0 | 38.0 | False | facebook_organic | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-17 14:12:33 | 2019-12-01 14:12:33 | False | 0.3303 | NaN | 14 | True | 1 | 2019-12-01 14:12:33 | 2020-04-01 14:12:33 | NaN | True | |
| 191560 | 227624 | 25843074 | enhanced | 2.0 | comedy | replace OTT | 27.301448 | 2.0 | 49.0 | False | google_organic | referral | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-06 18:02:13 | 2019-12-20 18:02:13 | False | 0.3303 | Paypal | 14 | True | 1 | 2019-12-20 18:02:13 | 2020-04-20 18:02:13 | NaN | True |
| 191561 | 227625 | 24799085 | base | NaN | comedy | access to exclusive content | 31.651317 | NaN | 45.0 | False | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-12-21 19:40:44 | 2020-01-04 19:40:44 | True | 0.0367 | NaN | 14 | True | 1 | 2020-01-04 19:40:44 | 2020-05-04 19:40:44 | NaN | True | ||
| 191562 | 227627 | 20166335 | base | NaN | comedy | replace OTT | 25.851492 | NaN | 55.0 | False | organic | tv | iOS | base_uae_14_day_trial | 4.7343 | 4.5141 | 2019-11-26 19:09:09 | 2019-12-10 19:09:09 | False | 0.0367 | NaN | 14 | False | 0 | NaN | NaN | 2019-12-09 00:00:00 | False |